﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

/****** Object:  Table [Person].[PhoneNumberType]    Script Date: 04/13/2010 13:02:04 ******/
SET IDENTITY_INSERT [Person].[PhoneNumberType] ON
INSERT [Person].[PhoneNumberType] ([Id], [Name], [ModifiedDate]) VALUES (1, N'Home', CAST(0x00009D4600000000 AS DateTime))
INSERT [Person].[PhoneNumberType] ([Id], [Name], [ModifiedDate]) VALUES (2, N'Cell', CAST(0x00009D4600000000 AS DateTime))
INSERT [Person].[PhoneNumberType] ([Id], [Name], [ModifiedDate]) VALUES (3, N'Work', CAST(0x00009D4600000000 AS DateTime))
SET IDENTITY_INSERT [Person].[PhoneNumberType] OFF
/****** Object:  Table [Event].[GuestType]    Script Date: 04/13/2010 13:02:04 ******/
SET IDENTITY_INSERT [Event].[GuestType] ON
INSERT [Event].[GuestType] ([Id], [Name], [ModifiedDate]) VALUES (1, N'Contact', CAST(0x00009D5700000000 AS DateTime))
INSERT [Event].[GuestType] ([Id], [Name], [ModifiedDate]) VALUES (2, N'Family', CAST(0x00009D5700000000 AS DateTime))
SET IDENTITY_INSERT [Event].[GuestType] OFF
/****** Object:  Table [Person].[EmailAddressType]    Script Date: 04/13/2010 13:02:04 ******/
SET IDENTITY_INSERT [Person].[EmailAddressType] ON
INSERT [Person].[EmailAddressType] ([Id], [Name], [ModifiedDate]) VALUES (1, N'Personal', CAST(0x00009D4600000000 AS DateTime))
INSERT [Person].[EmailAddressType] ([Id], [Name], [ModifiedDate]) VALUES (2, N'Work', CAST(0x00009D4600000000 AS DateTime))
SET IDENTITY_INSERT [Person].[EmailAddressType] OFF
/****** Object:  Table [Person].[AddressType]    Script Date: 04/13/2010 13:02:04 ******/
SET IDENTITY_INSERT [Person].[AddressType] ON
INSERT [Person].[AddressType] ([Id], [Name], [ModifiedDate]) VALUES (1, N'Home', CAST(0x00009CE900FE74E0 AS DateTime))
INSERT [Person].[AddressType] ([Id], [Name], [ModifiedDate]) VALUES (2, N'Work', CAST(0x00009CE900FE74E0 AS DateTime))
INSERT [Person].[AddressType] ([Id], [Name], [ModifiedDate]) VALUES (3, N'Vacation', CAST(0x00009CE900FE82BE AS DateTime))
SET IDENTITY_INSERT [Person].[AddressType] OFF

/****** Object:  Table [Person].[CountryRegion]    Script Date: 05/13/2010 19:49:06 ******/
GO
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AD', N'Andorra', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AE', N'United Arab Emirates', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AF', N'Afghanistan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AG', N'Antigua and Barbuda', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AI', N'Anguilla', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AL', N'Albania', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AM', N'Armenia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AN', N'Netherlands Antilles', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AO', N'Angola', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AQ', N'Antarctica', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AR', N'Argentina', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AS', N'American Samoa', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AT', N'Austria', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AU', N'Australia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AW', N'Aruba', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'AZ', N'Azerbaijan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BA', N'Bosnia and Herzegovina', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BB', N'Barbados', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BD', N'Bangladesh', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BE', N'Belgium', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BF', N'Burkina Faso', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BG', N'Bulgaria', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BH', N'Bahrain', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BI', N'Burundi', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BJ', N'Benin', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BM', N'Bermuda', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BN', N'Brunei', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BO', N'Bolivia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BR', N'Brazil', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BS', N'Bahamas, The', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BT', N'Bhutan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BV', N'Bouvet Island', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BW', N'Botswana', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BY', N'Belarus', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'BZ', N'Belize', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CA', N'Canada', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CC', N'Cocos (Keeling) Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CD', N'Congo (DRC)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CF', N'Central African Republic', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CG', N'Congo', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CH', N'Switzerland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CI', N'Côte d''Ivoire', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CK', N'Cook Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CL', N'Chile', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CM', N'Cameroon', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CN', N'China', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CO', N'Colombia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CR', N'Costa Rica', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CS', N'Serbia and Montenegro', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CU', N'Cuba', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CV', N'Cape Verde', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CX', N'Christmas Island', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CY', N'Cyprus', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'CZ', N'Czech Republic', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DE', N'Germany', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DJ', N'Djibouti', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DK', N'Denmark', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DM', N'Dominica', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DO', N'Dominican Republic', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'DZ', N'Algeria', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'EC', N'Ecuador', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'EE', N'Estonia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'EG', N'Egypt', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ER', N'Eritrea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ES', N'Spain', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ET', N'Ethiopia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FI', N'Finland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FJ', N'Fiji Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FK', N'Falkland Islands (Islas Malvinas)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FM', N'Micronesia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FO', N'Faroe Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'FR', N'France', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GA', N'Gabon', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GB', N'United Kingdom', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GD', N'Grenada', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GE', N'Georgia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GF', N'French Guiana', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GH', N'Ghana', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GI', N'Gibraltar', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GL', N'Greenland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GM', N'Gambia, The', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GN', N'Guinea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GP', N'Guadeloupe', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GQ', N'Equatorial Guinea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GR', N'Greece', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GS', N'South Georgia and the South Sandwich Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GT', N'Guatemala', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GU', N'Guam', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GW', N'Guinea-Bissau', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'GY', N'Guyana', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HK', N'Hong Kong SAR', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HM', N'Heard Island and McDonald Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HN', N'Honduras', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HR', N'Croatia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HT', N'Haiti', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'HU', N'Hungary', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ID', N'Indonesia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IE', N'Ireland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IL', N'Israel', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IN', N'India', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IO', N'British Indian Ocean Territory', CAST(0x00008C6900000000 AS DateTime))
GO
print 'Processed 100 total records'
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IQ', N'Iraq', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IR', N'Iran', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IS', N'Iceland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'IT', N'Italy', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'JM', N'Jamaica', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'JO', N'Jordan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'JP', N'Japan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KE', N'Kenya', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KG', N'Kyrgyzstan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KH', N'Cambodia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KI', N'Kiribati', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KM', N'Comoros', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KN', N'Saint Kitts and Nevis', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KP', N'North Korea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KR', N'Korea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KW', N'Kuwait', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KY', N'Cayman Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'KZ', N'Kazakhstan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LA', N'Laos', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LB', N'Lebanon', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LC', N'Saint Lucia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LI', N'Liechtenstein', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LK', N'Sri Lanka', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LR', N'Liberia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LS', N'Lesotho', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LT', N'Lithuania', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LU', N'Luxembourg', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LV', N'Latvia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'LY', N'Libya', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MA', N'Morocco', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MC', N'Monaco', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MD', N'Moldova', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MG', N'Madagascar', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MH', N'Marshall Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MK', N'Macedonia, Former Yugoslav Republic of', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ML', N'Mali', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MM', N'Myanmar', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MN', N'Mongolia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MO', N'Macao SAR', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MP', N'Northern Mariana Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MQ', N'Martinique', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MR', N'Mauritania', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MS', N'Montserrat', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MT', N'Malta', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MU', N'Mauritius', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MV', N'Maldives', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MW', N'Malawi', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MX', N'Mexico', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MY', N'Malaysia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'MZ', N'Mozambique', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NA', N'Namibia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NC', N'New Caledonia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NE', N'Niger', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NF', N'Norfolk Island', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NG', N'Nigeria', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NI', N'Nicaragua', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NL', N'Netherlands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NO', N'Norway', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NP', N'Nepal', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NR', N'Nauru', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NU', N'Niue', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'NZ', N'New Zealand', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'OM', N'Oman', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PA', N'Panama', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PE', N'Peru', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PF', N'French Polynesia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PG', N'Papua New Guinea', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PH', N'Philippines', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PK', N'Pakistan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PL', N'Poland', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PM', N'Saint Pierre and Miquelon', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PN', N'Pitcairn Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PR', N'Puerto Rico', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PS', N'Palestinian Authority', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PT', N'Portugal', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PW', N'Palau', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'PY', N'Paraguay', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'QA', N'Qatar', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'RE', N'Réunion', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'RO', N'Romania', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'RU', N'Russia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'RW', N'Rwanda', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SA', N'Saudi Arabia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SB', N'Solomon Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SC', N'Seychelles', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SD', N'Sudan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SE', N'Sweden', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SG', N'Singapore', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SH', N'Saint Helena', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SI', N'Slovenia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SJ', N'Svalbard and Jan Mayen', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SK', N'Slovakia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SL', N'Sierra Leone', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SM', N'San Marino', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SN', N'Senegal', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SO', N'Somalia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SR', N'Suriname', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ST', N'São Tomé and Príncipe', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SV', N'El Salvador', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SY', N'Syria', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'SZ', N'Swaziland', CAST(0x00008C6900000000 AS DateTime))
GO
print 'Processed 200 total records'
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TC', N'Turks and Caicos Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TD', N'Chad', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TF', N'French Southern and Antarctic Lands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TG', N'Togo', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TH', N'Thailand', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TJ', N'Tajikistan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TK', N'Tokelau', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TL', N'Timor-Leste', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TM', N'Turkmenistan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TN', N'Tunisia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TO', N'Tonga', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TR', N'Turkey', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TT', N'Trinidad and Tobago', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TV', N'Tuvalu', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TW', N'Taiwan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'TZ', N'Tanzania', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'UA', N'Ukraine', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'UG', N'Uganda', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'UM', N'U.S. Minor Outlying Islands', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'US', N'United States', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'UY', N'Uruguay', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'UZ', N'Uzbekistan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VA', N'Vatican City', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VC', N'Saint Vincent and the Grenadine', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VE', N'Venezuela', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VG', N'Virgin Islands, British', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VI', N'Virgin Islands, U.S.', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VN', N'Vietnam', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'VU', N'Vanuatu', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'WF', N'Wallis and Futuna', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'WS', N'Samoa', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'YE', N'Yemen', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'YT', N'Mayotte', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ZA', N'South Africa', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ZM', N'Zambia', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[CountryRegion] ([CountryRegionCode], [Name], [ModifiedDate]) VALUES (N'ZW', N'Zimbabwe', CAST(0x00008C6900000000 AS DateTime))

/****** Object:  Table [Person].[StateProvince]    Script Date: 04/13/2010 13:02:04 ******/
SET IDENTITY_INSERT [Person].[StateProvince] ON
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (1, N'AB ', N'CA', 0, N'Alberta', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (2, N'AK ', N'US', 0, N'Alaska', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (3, N'AL ', N'US', 0, N'Alabama', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (4, N'AR ', N'US', 0, N'Arkansas', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (5, N'AS ', N'AS', 1, N'American Samoa', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (6, N'AZ ', N'US', 0, N'Arizona', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (7, N'BC ', N'CA', 0, N'British Columbia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (8, N'BY ', N'DE', 0, N'Bayern', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (9, N'CA ', N'US', 0, N'California', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (10, N'CO ', N'US', 0, N'Colorado', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (11, N'CT ', N'US', 0, N'Connecticut', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (12, N'DC ', N'US', 0, N'District of Columbia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (13, N'DE ', N'US', 0, N'Delaware', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (14, N'ENG', N'GB', 1, N'England', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (15, N'FL ', N'US', 0, N'Florida', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (16, N'FM ', N'FM', 1, N'Micronesia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (17, N'GA ', N'US', 0, N'Georgia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (18, N'GU ', N'US', 0, N'Guam', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (19, N'HE ', N'DE', 0, N'Hessen', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (20, N'HH ', N'DE', 0, N'Hamburg', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (21, N'HI ', N'US', 0, N'Hawaii', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (22, N'IA ', N'US', 0, N'Iowa', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (23, N'ID ', N'US', 0, N'Idaho', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (24, N'IL ', N'US', 0, N'Illinois', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (25, N'IN ', N'US', 0, N'Indiana', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (26, N'KS ', N'US', 0, N'Kansas', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (27, N'KY ', N'US', 0, N'Kentucky', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (28, N'LA ', N'US', 0, N'Louisiana', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (29, N'LB ', N'CA', 0, N'Labrador', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (30, N'MA ', N'US', 0, N'Massachusetts', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (31, N'MB ', N'CA', 0, N'Manitoba', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (32, N'MD ', N'US', 0, N'Maryland', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (33, N'ME ', N'US', 0, N'Maine', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (34, N'MH ', N'MH', 1, N'Marshall Islands', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (35, N'MI ', N'US', 0, N'Michigan', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (36, N'MN ', N'US', 0, N'Minnesota', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (37, N'MO ', N'US', 0, N'Missouri', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (38, N'MP ', N'MP', 1, N'Northern Mariana Islands', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (39, N'MS ', N'US', 0, N'Mississippi', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (40, N'MT ', N'US', 0, N'Montana', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (41, N'NB ', N'CA', 0, N'Brunswick', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (42, N'NC ', N'US', 0, N'North Carolina', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (43, N'ND ', N'US', 0, N'North Dakota', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (44, N'NE ', N'US', 0, N'Nebraska', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (45, N'NF ', N'CA', 0, N'Newfoundland', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (46, N'NH ', N'US', 0, N'New Hampshire', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (47, N'NJ ', N'US', 0, N'New Jersey', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (48, N'NM ', N'US', 0, N'New Mexico', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (49, N'NS ', N'CA', 0, N'Nova Scotia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (50, N'NSW', N'AU', 0, N'New South Wales', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (51, N'NT ', N'CA', 0, N'Northwest Territories', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (52, N'NV ', N'US', 0, N'Nevada', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (53, N'NW ', N'DE', 0, N'Nordrhein-Westfalen', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (54, N'NY ', N'US', 0, N'New York', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (55, N'OH ', N'US', 0, N'Ohio', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (56, N'OK ', N'US', 0, N'Oklahoma', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (57, N'ON ', N'CA', 0, N'Ontario', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (58, N'OR ', N'US', 0, N'Oregon', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (59, N'PA ', N'US', 0, N'Pennsylvania', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (60, N'PE ', N'CA', 0, N'Prince Edward Island', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (61, N'PR ', N'US', 0, N'Puerto Rico', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (62, N'PW ', N'PW', 1, N'Palau', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (63, N'QC ', N'CA', 0, N'Quebec', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (64, N'QLD', N'AU', 0, N'Queensland', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (65, N'RI ', N'US', 0, N'Rhode Island', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (66, N'SA ', N'AU', 0, N'South Australia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (67, N'SC ', N'US', 0, N'South Carolina', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (68, N'SD ', N'US', 0, N'South Dakota', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (69, N'SK ', N'CA', 0, N'Saskatchewan', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (70, N'SL ', N'DE', 0, N'Saarland', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (71, N'TAS', N'AU', 0, N'Tasmania', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (72, N'TN ', N'US', 0, N'Tennessee', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (73, N'TX ', N'US', 0, N'Texas', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (74, N'UT ', N'US', 0, N'Utah', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (75, N'VA ', N'US', 0, N'Virginia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (76, N'VI ', N'VI', 1, N'Virgin Islands', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (77, N'VIC', N'AU', 0, N'Victoria', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (78, N'VT ', N'US', 0, N'Vermont', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (79, N'WA ', N'US', 0, N'Washington', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (80, N'WI ', N'US', 0, N'Wisconsin', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (81, N'WV ', N'US', 0, N'West Virginia', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (82, N'WY ', N'US', 0, N'Wyoming', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (83, N'YT ', N'CA', 0, N'Yukon Territory', CAST(0x000094A700A9901C AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (84, N'FR ', N'FR', 1, N'France', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (85, N'BB ', N'DE', 0, N'Brandenburg', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (86, N'SN ', N'DE', 0, N'Saxony', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (87, N'01 ', N'FR', 0, N'Ain', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (88, N'02 ', N'FR', 0, N'Aisne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (89, N'03 ', N'FR', 0, N'Allier', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (90, N'04 ', N'FR', 0, N'Alpes-de-Haute Provence', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (91, N'05 ', N'FR', 0, N'Alpes (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (92, N'06 ', N'FR', 0, N'Alpes-Maritimes', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (93, N'07 ', N'FR', 0, N'Ardèche', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (94, N'08 ', N'FR', 0, N'Ardennes', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (95, N'09 ', N'FR', 0, N'Ariège', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (96, N'10 ', N'FR', 0, N'Aube', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (97, N'11 ', N'FR', 0, N'Aude', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (98, N'12 ', N'FR', 0, N'Aveyron', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (99, N'13 ', N'FR', 0, N'Bouches du Rhône', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (100, N'14 ', N'FR', 0, N'Calvados', CAST(0x00008C6900000000 AS DateTime))
GO
print 'Processed 100 total records'
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (101, N'15 ', N'FR', 0, N'Cantal', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (102, N'16 ', N'FR', 0, N'Charente', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (103, N'17 ', N'FR', 0, N'Charente-Maritime', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (104, N'18 ', N'FR', 0, N'Cher', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (105, N'19 ', N'FR', 0, N'Corrèze', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (106, N'20 ', N'FR', 0, N'Corse', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (107, N'21 ', N'FR', 0, N'Côte d''Or', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (108, N'22 ', N'FR', 0, N'Côtes-d''Armor', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (109, N'23 ', N'FR', 0, N'Creuse', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (110, N'24 ', N'FR', 0, N'Dordogne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (111, N'25 ', N'FR', 0, N'Toubs', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (112, N'26 ', N'FR', 0, N'Drôme', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (113, N'27 ', N'FR', 0, N'Eure', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (114, N'28 ', N'FR', 0, N'Eure et Loir', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (115, N'29 ', N'FR', 0, N'Finistère', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (116, N'30 ', N'FR', 0, N'Gard', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (117, N'31 ', N'FR', 0, N'Garonne (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (118, N'32 ', N'FR', 0, N'Gers', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (119, N'33 ', N'FR', 0, N'Gironde', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (120, N'34 ', N'FR', 0, N'Hérault', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (121, N'35 ', N'FR', 0, N'Ille et Vilaine', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (122, N'36 ', N'FR', 0, N'Indre', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (123, N'37 ', N'FR', 0, N'Indre et Loire', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (124, N'38 ', N'FR', 0, N'Isère', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (125, N'39 ', N'FR', 0, N'Jura', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (126, N'40 ', N'FR', 0, N'Landes', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (127, N'41 ', N'FR', 0, N'Loir et Cher', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (128, N'42 ', N'FR', 0, N'Loire', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (129, N'43 ', N'FR', 0, N'Loire (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (130, N'44 ', N'FR', 0, N'Loire Atlantique', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (131, N'45 ', N'FR', 0, N'Loiret', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (132, N'46 ', N'FR', 0, N'Lot', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (133, N'47 ', N'FR', 0, N'Lot et Garonne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (134, N'48 ', N'FR', 0, N'Lozère', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (135, N'49 ', N'FR', 0, N'Maine et Loire', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (136, N'50 ', N'FR', 0, N'Manche', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (137, N'51 ', N'FR', 0, N'Marne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (138, N'52 ', N'FR', 0, N'Marne (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (139, N'53 ', N'FR', 0, N'Mayenne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (140, N'54 ', N'FR', 0, N'Meurthe et Moselle', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (141, N'55 ', N'FR', 0, N'Meuse', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (142, N'56 ', N'FR', 0, N'Morbihan', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (143, N'57 ', N'FR', 0, N'Moselle', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (144, N'58 ', N'FR', 0, N'Nièvre', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (145, N'59 ', N'FR', 0, N'Nord', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (146, N'60 ', N'FR', 0, N'Oise', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (147, N'61 ', N'FR', 0, N'Orne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (148, N'62 ', N'FR', 0, N'Pas de Calais', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (149, N'63 ', N'FR', 0, N'Puy de Dôme', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (150, N'64 ', N'FR', 0, N'Pyrénées Atlantiques', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (151, N'65 ', N'FR', 0, N'Pyrénées (Hautes)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (152, N'66 ', N'FR', 0, N'Pyrénées Orientales', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (153, N'67 ', N'FR', 0, N'Rhin (Bas)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (154, N'68 ', N'FR', 0, N'Rhin (Haut)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (155, N'69 ', N'FR', 0, N'Rhône', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (156, N'70 ', N'FR', 0, N'Saône (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (157, N'71 ', N'FR', 0, N'Saône et Loire', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (158, N'72 ', N'FR', 0, N'Sarthe', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (159, N'73 ', N'FR', 0, N'Savoie', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (160, N'74 ', N'FR', 0, N'Savoie Haute', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (161, N'75 ', N'FR', 0, N'Seine (Paris)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (162, N'76 ', N'FR', 0, N'Seine Maritime', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (163, N'77 ', N'FR', 0, N'Seine et Marne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (164, N'78 ', N'FR', 0, N'Yveline', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (165, N'79 ', N'FR', 0, N'Sèvres (Deux)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (166, N'80 ', N'FR', 0, N'Somme', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (167, N'81 ', N'FR', 0, N'Tarne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (168, N'82 ', N'FR', 0, N'Tarne et Garonne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (169, N'83 ', N'FR', 0, N'Var', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (170, N'84 ', N'FR', 0, N'Vaucluse', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (171, N'85 ', N'FR', 0, N'La Vendée', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (172, N'86 ', N'FR', 0, N'Vienne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (173, N'87 ', N'FR', 0, N'Vienne (Haute)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (174, N'88 ', N'FR', 0, N'Vosges', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (175, N'89 ', N'FR', 0, N'Yonne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (176, N'90 ', N'FR', 0, N'Belford (Territoire de)', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (177, N'91 ', N'FR', 0, N'Essonne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (178, N'92 ', N'FR', 0, N'Hauts de Seine', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (179, N'93 ', N'FR', 0, N'Seine Saint Denis', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (180, N'94 ', N'FR', 0, N'Val de Marne', CAST(0x00008C6900000000 AS DateTime))
INSERT [Person].[StateProvince] ([Id], [StateProvinceCode], [CountryRegionCode], [IsOnlyStateProvinceFlag], [Name], [ModifiedDate]) VALUES (181, N'95 ', N'FR', 0, N'Val d''Oise', CAST(0x00008C6900000000 AS DateTime))
SET IDENTITY_INSERT [Person].[StateProvince] OFF
